Professional BI developers using Analysis Services and advanced users working with Power BI share a common pain. Their productivity editing a large data model is much lower than what you might expect in 2017. There are many reasons for that.…  Read more

Microsoft recently released the Analyze in Excel feature, which allows you to connect an Excel pivot table to a data model published on Power BI. I think/hope that Microsoft will enhance this feature to extend its current limits. For example,…  Read more

After months of public preview, Microsoft today is releasing the Power BI service to general availability. The preview was really a beta that evolved in these months, and I personally liked the approach that MS developers have now. I did…  Read more

The August 2015 update of Power BI Desktop added two important features for existing Excel and Analysis Services users: Import Excel Power BI artifacts (Data Model, Queries, Power View) into a new Power BI Desktop file Live Analysis Services Connections: Ability…  Read more

I wrote this blog post with Alberto Ferrari. A few days ago, during the Build conference, Microsoft announced the availability, although still in preview, of Power BI Embedded. In a few words, Power BI Embedded lets you embed Power BI…  Read more

In the last few years, the Business Intelligence (BI) world has been moving towards self-service BI. As expected, several vendors created tools empowering regular users to gain insights from their data. Among the many, there is Power BI. Nowadays, users…  Read more

Less than a month ago, Microsoft introduced the External Tools feature in the Power BI Desktop July 2020 release. By using DAX Studio, you were already able to create a PivotTable in Excel connected to the model hosted by Power…  Read more

The 2015 has been an amazing year for Power BI. One year ago, I was commenting on this blog the public preview of Power BI dashboards. A few days ago, Microsoft released the December update of Power BI Desktop and…  Read more

If you import more than one table into Power BI or Power Pivot, you have a data model. When you have more than one table, you usually have relationships between tables. When you analyze data, you often have many choices…  Read more

Just a few days before my session about Power Query at TechEd 2014, Microsoft released a new update that enables the scheduled data refresh of a Power Pivot workbook containing Power Query transformations. This is a very good news, because…  Read more